Dataset statistics
| Number of variables | 16 |
|---|---|
| Number of observations | 47935 |
| Missing cells | 288011 |
| Missing cells (%) | 37.6% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 5.9 MiB |
| Average record size in memory | 128.0 B |
Variable types
| Categorical | 6 |
|---|---|
| Numeric | 9 |
| Unsupported | 1 |
Unnamed: 10 has constant value "#NAME?" | Constant |
Unnamed: 11 has constant value "#NAME?" | Constant |
country has a high cardinality: 204 distinct values | High cardinality |
pub_id is highly overall correlated with Unnamed: 13 and 1 other fields | High correlation |
app_id is highly overall correlated with Unnamed: 13 and 1 other fields | High correlation |
ad_unit_code is highly overall correlated with Unnamed: 15 and 2 other fields | High correlation |
requests is highly overall correlated with ae_responses and 3 other fields | High correlation |
ae_responses is highly overall correlated with requests and 4 other fields | High correlation |
ae_impressions is highly overall correlated with requests and 5 other fields | High correlation |
ae_clicks is highly overall correlated with ae_impressions and 3 other fields | High correlation |
ae_revenue is highly overall correlated with ae_responses and 4 other fields | High correlation |
Unnamed: 15 is highly overall correlated with ad_unit_code and 3 other fields | High correlation |
date is highly overall correlated with Unnamed: 15 and 2 other fields | High correlation |
Unnamed: 13 is highly overall correlated with pub_id and 10 other fields | High correlation |
Unnamed: 14 is highly overall correlated with pub_id and 10 other fields | High correlation |
Unnamed: 10 has 47934 (> 99.9%) missing values | Missing |
Unnamed: 11 has 47934 (> 99.9%) missing values | Missing |
Unnamed: 12 has 47935 (100.0%) missing values | Missing |
Unnamed: 13 has 47929 (> 99.9%) missing values | Missing |
Unnamed: 14 has 47930 (> 99.9%) missing values | Missing |
Unnamed: 15 has 47929 (> 99.9%) missing values | Missing |
requests is highly skewed (γ1 = 21.74933334) | Skewed |
ae_responses is highly skewed (γ1 = 22.84978943) | Skewed |
ae_impressions is highly skewed (γ1 = 21.14684899) | Skewed |
ae_clicks is highly skewed (γ1 = 38.07757129) | Skewed |
ae_revenue is highly skewed (γ1 = 42.19101501) | Skewed |
Unnamed: 13 is uniformly distributed | Uniform |
Unnamed: 14 is uniformly distributed | Uniform |
Unnamed: 12 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
ae_clicks has 14839 (31.0%) zeros | Zeros |
Reproduction
| Analysis started | 2023-04-14 17:23:12.539128 |
|---|---|
| Analysis finished | 2023-04-14 17:23:35.296626 |
| Duration | 22.76 seconds |
| Software version | pandas-profiling vv3.6.3 |
| Download configuration | config.json |
date
Categorical
| Distinct | 31 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 374.6 KiB |
| 07-10-2022 | 1783 |
|---|---|
| 08-10-2022 | 1758 |
| 06-10-2022 | 1737 |
| 02-10-2022 | 1724 |
| 05-10-2022 | 1711 |
| Other values (26) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 479350 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 20-10-2022 |
|---|---|
| 2nd row | 20-10-2022 |
| 3rd row | 20-10-2022 |
| 4th row | 20-10-2022 |
| 5th row | 20-10-2022 |
Common Values
| Value | Count | Frequency (%) |
| 07-10-2022 | 1783 | 3.7% |
| 08-10-2022 | 1758 | 3.7% |
| 06-10-2022 | 1737 | 3.6% |
| 02-10-2022 | 1724 | 3.6% |
| 05-10-2022 | 1711 | 3.6% |
| 04-10-2022 | 1686 | 3.5% |
| 09-10-2022 | 1676 | 3.5% |
| 03-10-2022 | 1667 | 3.5% |
| 01-10-2022 | 1613 | 3.4% |
| 19-10-2022 | 1570 | 3.3% |
| Other values (21) | 31010 |
Length
| Value | Count | Frequency (%) |
| 07-10-2022 | 1783 | 3.7% |
| 08-10-2022 | 1758 | 3.7% |
| 06-10-2022 | 1737 | 3.6% |
| 02-10-2022 | 1724 | 3.6% |
| 05-10-2022 | 1711 | 3.6% |
| 04-10-2022 | 1686 | 3.5% |
| 09-10-2022 | 1676 | 3.5% |
| 03-10-2022 | 1667 | 3.5% |
| 01-10-2022 | 1613 | 3.4% |
| 19-10-2022 | 1570 | 3.3% |
| Other values (21) | 31010 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 163596 | |
| 0 | 115674 | |
| - | 95870 | |
| 1 | 68460 | |
| 3 | 7501 | 1.6% |
| 9 | 4764 | 1.0% |
| 8 | 4758 | 1.0% |
| 5 | 4729 | 1.0% |
| 7 | 4697 | 1.0% |
| 4 | 4668 | 1.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 383480 | |
| Dash Punctuation | 95870 | 20.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 163596 | |
| 0 | 115674 | |
| 1 | 68460 | |
| 3 | 7501 | 2.0% |
| 9 | 4764 | 1.2% |
| 8 | 4758 | 1.2% |
| 5 | 4729 | 1.2% |
| 7 | 4697 | 1.2% |
| 4 | 4668 | 1.2% |
| 6 | 4633 | 1.2% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 95870 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 479350 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 163596 | |
| 0 | 115674 | |
| - | 95870 | |
| 1 | 68460 | |
| 3 | 7501 | 1.6% |
| 9 | 4764 | 1.0% |
| 8 | 4758 | 1.0% |
| 5 | 4729 | 1.0% |
| 7 | 4697 | 1.0% |
| 4 | 4668 | 1.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 479350 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 163596 | |
| 0 | 115674 | |
| - | 95870 | |
| 1 | 68460 | |
| 3 | 7501 | 1.6% |
| 9 | 4764 | 1.0% |
| 8 | 4758 | 1.0% |
| 5 | 4729 | 1.0% |
| 7 | 4697 | 1.0% |
| 4 | 4668 | 1.0% |
pub_id
Real number (ℝ)
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 413.18821 |
| Minimum | 14 |
|---|---|
| Maximum | 2808 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 374.6 KiB |
Quantile statistics
| Minimum | 14 |
|---|---|
| 5-th percentile | 14 |
| Q1 | 14 |
| median | 51 |
| Q3 | 72 |
| 95-th percentile | 2808 |
| Maximum | 2808 |
| Range | 2794 |
| Interquartile range (IQR) | 58 |
Descriptive statistics
| Standard deviation | 893.64566 |
|---|---|
| Coefficient of variation (CV) | 2.1628053 |
| Kurtosis | 2.9881305 |
| Mean | 413.18821 |
| Median Absolute Deviation (MAD) | 37 |
| Skewness | 2.1893061 |
| Sum | 19806177 |
| Variance | 798602.56 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 14 | 17349 | |
| 51 | 14949 | |
| 2808 | 5442 | 11.4% |
| 72 | 4906 | 10.2% |
| 281 | 2317 | 4.8% |
| 879 | 1605 | 3.3% |
| 107 | 557 | 1.2% |
| 1987 | 521 | 1.1% |
| 34 | 289 | 0.6% |
| Value | Count | Frequency (%) |
| 14 | 17349 | |
| 34 | 289 | 0.6% |
| 51 | 14949 | |
| 72 | 4906 | 10.2% |
| 107 | 557 | 1.2% |
| 281 | 2317 | 4.8% |
| 879 | 1605 | 3.3% |
| 1987 | 521 | 1.1% |
| 2808 | 5442 | 11.4% |
| Value | Count | Frequency (%) |
| 2808 | 5442 | 11.4% |
| 1987 | 521 | 1.1% |
| 879 | 1605 | 3.3% |
| 281 | 2317 | 4.8% |
| 107 | 557 | 1.2% |
| 72 | 4906 | 10.2% |
| 51 | 14949 | |
| 34 | 289 | 0.6% |
| 14 | 17349 |
app_id
Real number (ℝ)
| Distinct | 10 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 50155772 |
| Minimum | 16243270 |
|---|---|
| Maximum | 95674771 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 374.6 KiB |
Quantile statistics
| Minimum | 16243270 |
|---|---|
| 5-th percentile | 22693095 |
| Q1 | 25596802 |
| median | 47862278 |
| Q3 | 47862278 |
| 95-th percentile | 95674771 |
| Maximum | 95674771 |
| Range | 79431501 |
| Interquartile range (IQR) | 22265476 |
Descriptive statistics
| Standard deviation | 24657717 |
|---|---|
| Coefficient of variation (CV) | 0.49162273 |
| Kurtosis | -0.70216238 |
| Mean | 50155772 |
| Median Absolute Deviation (MAD) | 22265476 |
| Skewness | 0.68752648 |
| Sum | 2.4042169 × 1012 |
| Variance | 6.0800303 × 1014 |
| Monotonicity | Increasing |
| Value | Count | Frequency (%) |
| 47862278 | 14949 | |
| 22693095 | 11291 | |
| 95674771 | 6058 | |
| 43840611 | 5442 | 11.4% |
| 84650721 | 4906 | 10.2% |
| 40931528 | 2317 | 4.8% |
| 25596802 | 1605 | 3.3% |
| 63338696 | 557 | 1.2% |
| 16243270 | 521 | 1.1% |
| 66981243 | 289 | 0.6% |
| Value | Count | Frequency (%) |
| 16243270 | 521 | 1.1% |
| 22693095 | 11291 | |
| 25596802 | 1605 | 3.3% |
| 40931528 | 2317 | 4.8% |
| 43840611 | 5442 | 11.4% |
| 47862278 | 14949 | |
| 63338696 | 557 | 1.2% |
| 66981243 | 289 | 0.6% |
| 84650721 | 4906 | 10.2% |
| 95674771 | 6058 |
| Value | Count | Frequency (%) |
| 95674771 | 6058 | |
| 84650721 | 4906 | 10.2% |
| 66981243 | 289 | 0.6% |
| 63338696 | 557 | 1.2% |
| 47862278 | 14949 | |
| 43840611 | 5442 | 11.4% |
| 40931528 | 2317 | 4.8% |
| 25596802 | 1605 | 3.3% |
| 22693095 | 11291 | |
| 16243270 | 521 | 1.1% |
ad_unit_code
Real number (ℝ)
| Distinct | 56 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.2684021 × 1010 |
| Minimum | 2.2477474 × 1010 |
|---|---|
| Maximum | 2.283576 × 1010 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 374.6 KiB |
Quantile statistics
| Minimum | 2.2477474 × 1010 |
|---|---|
| 5-th percentile | 2.2477733 × 1010 |
| Q1 | 2.2521511 × 1010 |
| median | 2.275208 × 1010 |
| Q3 | 2.2770341 × 1010 |
| 95-th percentile | 2.2827807 × 1010 |
| Maximum | 2.283576 × 1010 |
| Range | 3.5828642 × 108 |
| Interquartile range (IQR) | 2.488309 × 108 |
Descriptive statistics
| Standard deviation | 1.215869 × 108 |
|---|---|
| Coefficient of variation (CV) | 0.0053600243 |
| Kurtosis | -1.1893423 |
| Mean | 2.2684021 × 1010 |
| Median Absolute Deviation (MAD) | 54282040 |
| Skewness | -0.6484422 |
| Sum | 1.0873585 × 1015 |
| Variance | 1.4783375 × 1016 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2.275263244 × 1010 | 4808 | 10.0% |
| 2.275208048 × 1010 | 4617 | 9.6% |
| 2.277034143 × 1010 | 2553 | 5.3% |
| 2.269779844 × 1010 | 2485 | 5.2% |
| 2.275208067 × 1010 | 1866 | 3.9% |
| 2.278852573 × 1010 | 1801 | 3.8% |
| 2.277034105 × 1010 | 1745 | 3.6% |
| 2.252151044 × 1010 | 1692 | 3.5% |
| 2.27703416 × 1010 | 1647 | 3.4% |
| 2.252150936 × 1010 | 1614 | 3.4% |
| Other values (46) | 23107 |
| Value | Count | Frequency (%) |
| 2.24774737 × 1010 | 1525 | |
| 2.247773309 × 1010 | 994 | |
| 2.247773311 × 1010 | 815 | |
| 2.247773316 × 1010 | 107 | 0.2% |
| 2.248763942 × 1010 | 1186 | |
| 2.248763971 × 1010 | 923 | |
| 2.248763972 × 1010 | 848 | |
| 2.252149148 × 1010 | 157 | 0.3% |
| 2.252150936 × 1010 | 1614 | |
| 2.252151027 × 1010 | 1590 |
| Value | Count | Frequency (%) |
| 2.283576012 × 1010 | 663 | |
| 2.283540832 × 1010 | 1182 | |
| 2.283284659 × 1010 | 206 | 0.4% |
| 2.283284644 × 1010 | 226 | 0.5% |
| 2.283282773 × 1010 | 89 | 0.2% |
| 2.282780711 × 1010 | 555 | |
| 2.282780606 × 1010 | 624 | |
| 2.282747522 × 1010 | 590 | |
| 2.282747502 × 1010 | 548 | |
| 2.282064594 × 1010 | 96 | 0.2% |
country
Categorical
| Distinct | 204 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 420 |
| Missing (%) | 0.9% |
| Memory size | 374.6 KiB |
| India | 1230 |
|---|---|
| United States | 974 |
| Brazil | 911 |
| Saudi Arabia | 879 |
| Nigeria | 878 |
| Other values (199) |
Length
| Max length | 32 |
|---|---|
| Median length | 22 |
| Mean length | 8.1724087 |
| Min length | 4 |
Characters and Unicode
| Total characters | 388312 |
|---|---|
| Distinct characters | 57 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 6 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Tanzania |
|---|---|
| 2nd row | Tanzania |
| 3rd row | Thailand |
| 4th row | Thailand |
| 5th row | Thailand |
Common Values
| Value | Count | Frequency (%) |
| India | 1230 | 2.6% |
| United States | 974 | 2.0% |
| Brazil | 911 | 1.9% |
| Saudi Arabia | 879 | 1.8% |
| Nigeria | 878 | 1.8% |
| France | 812 | 1.7% |
| United Kingdom | 811 | 1.7% |
| Pakistan | 803 | 1.7% |
| South Africa | 780 | 1.6% |
| Mexico | 761 | 1.6% |
| Other values (194) | 38676 |
Length
| Value | Count | Frequency (%) |
| united | 2344 | 4.1% |
| india | 1230 | 2.2% |
| south | 1210 | 2.1% |
| states | 974 | 1.7% |
| brazil | 911 | 1.6% |
| saudi | 879 | 1.5% |
| arabia | 879 | 1.5% |
| nigeria | 878 | 1.5% |
| france | 812 | 1.4% |
| kingdom | 811 | 1.4% |
| Other values (227) | 46281 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 60619 | |
| i | 35875 | 9.2% |
| n | 29945 | 7.7% |
| e | 28166 | 7.3% |
| r | 21816 | 5.6% |
| o | 17534 | 4.5% |
| t | 16475 | 4.2% |
| d | 14106 | 3.6% |
| l | 13719 | 3.5% |
| u | 11467 | 3.0% |
| Other values (47) | 138590 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 320884 | |
| Uppercase Letter | 56556 | 14.6% |
| Space Separator | 9694 | 2.5% |
| Other Punctuation | 385 | 0.1% |
| Open Punctuation | 341 | 0.1% |
| Close Punctuation | 341 | 0.1% |
| Dash Punctuation | 111 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 60619 | |
| i | 35875 | |
| n | 29945 | |
| e | 28166 | 8.8% |
| r | 21816 | 6.8% |
| o | 17534 | 5.5% |
| t | 16475 | 5.1% |
| d | 14106 | 4.4% |
| l | 13719 | 4.3% |
| u | 11467 | 3.6% |
| Other values (16) | 71162 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 7183 | |
| A | 4992 | 8.8% |
| I | 4211 | 7.4% |
| B | 4100 | 7.2% |
| U | 3681 | 6.5% |
| C | 3650 | 6.5% |
| M | 3442 | 6.1% |
| P | 3224 | 5.7% |
| K | 3070 | 5.4% |
| T | 2853 | 5.0% |
| Other values (15) | 16150 |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 383 | |
| . | 2 | 0.5% |
Space Separator
| Value | Count | Frequency (%) |
| 9694 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 341 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 341 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 111 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 377440 | |
| Common | 10872 | 2.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 60619 | |
| i | 35875 | 9.5% |
| n | 29945 | 7.9% |
| e | 28166 | 7.5% |
| r | 21816 | 5.8% |
| o | 17534 | 4.6% |
| t | 16475 | 4.4% |
| d | 14106 | 3.7% |
| l | 13719 | 3.6% |
| u | 11467 | 3.0% |
| Other values (41) | 127718 |
Common
| Value | Count | Frequency (%) |
| 9694 | ||
| ' | 383 | 3.5% |
| ( | 341 | 3.1% |
| ) | 341 | 3.1% |
| - | 111 | 1.0% |
| . | 2 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 388312 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 60619 | |
| i | 35875 | 9.2% |
| n | 29945 | 7.7% |
| e | 28166 | 7.3% |
| r | 21816 | 5.6% |
| o | 17534 | 4.5% |
| t | 16475 | 4.2% |
| d | 14106 | 3.6% |
| l | 13719 | 3.5% |
| u | 11467 | 3.0% |
| Other values (47) | 138590 |
requests
Real number (ℝ)
HIGH CORRELATION  SKEWED 
| Distinct | 3783 |
|---|---|
| Distinct (%) | 7.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 585.82781 |
| Minimum | 16 |
|---|---|
| Maximum | 156435 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 374.6 KiB |
Quantile statistics
| Minimum | 16 |
|---|---|
| 5-th percentile | 24 |
| Q1 | 50 |
| median | 109 |
| Q3 | 300 |
| 95-th percentile | 1960 |
| Maximum | 156435 |
| Range | 156419 |
| Interquartile range (IQR) | 250 |
Descriptive statistics
| Standard deviation | 3024.6865 |
|---|---|
| Coefficient of variation (CV) | 5.1630982 |
| Kurtosis | 683.38141 |
| Mean | 585.82781 |
| Median Absolute Deviation (MAD) | 74 |
| Skewness | 21.749333 |
| Sum | 28081656 |
| Variance | 9148728.3 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 27 | 404 | 0.8% |
| 28 | 404 | 0.8% |
| 32 | 397 | 0.8% |
| 30 | 389 | 0.8% |
| 23 | 388 | 0.8% |
| 35 | 383 | 0.8% |
| 33 | 382 | 0.8% |
| 25 | 382 | 0.8% |
| 31 | 375 | 0.8% |
| 41 | 374 | 0.8% |
| Other values (3773) | 44057 |
| Value | Count | Frequency (%) |
| 16 | 158 | |
| 17 | 195 | |
| 18 | 277 | |
| 19 | 308 | |
| 20 | 340 | |
| 21 | 350 | |
| 22 | 370 | |
| 23 | 388 | |
| 24 | 350 | |
| 25 | 382 |
| Value | Count | Frequency (%) |
| 156435 | 1 | |
| 128311 | 1 | |
| 120564 | 1 | |
| 120331 | 1 | |
| 115997 | 1 | |
| 109421 | 1 | |
| 107968 | 1 | |
| 103295 | 1 | |
| 97698 | 1 | |
| 96027 | 1 |
ae_responses
Real number (ℝ)
HIGH CORRELATION  SKEWED 
| Distinct | 3636 |
|---|---|
| Distinct (%) | 7.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 516.9182 |
| Minimum | 16 |
|---|---|
| Maximum | 156296 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 374.6 KiB |
Quantile statistics
| Minimum | 16 |
|---|---|
| 5-th percentile | 23 |
| Q1 | 47 |
| median | 100 |
| Q3 | 275 |
| 95-th percentile | 1816 |
| Maximum | 156296 |
| Range | 156280 |
| Interquartile range (IQR) | 228 |
Descriptive statistics
| Standard deviation | 2579.6957 |
|---|---|
| Coefficient of variation (CV) | 4.9905299 |
| Kurtosis | 805.17104 |
| Mean | 516.9182 |
| Median Absolute Deviation (MAD) | 67 |
| Skewness | 22.849789 |
| Sum | 24778474 |
| Variance | 6654830 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 28 | 465 | 1.0% |
| 31 | 434 | 0.9% |
| 25 | 433 | 0.9% |
| 32 | 431 | 0.9% |
| 29 | 422 | 0.9% |
| 27 | 420 | 0.9% |
| 22 | 420 | 0.9% |
| 23 | 416 | 0.9% |
| 26 | 413 | 0.9% |
| 40 | 408 | 0.9% |
| Other values (3626) | 43673 |
| Value | Count | Frequency (%) |
| 16 | 177 | |
| 17 | 243 | |
| 18 | 326 | |
| 19 | 340 | |
| 20 | 390 | |
| 21 | 389 | |
| 22 | 420 | |
| 23 | 416 | |
| 24 | 377 | |
| 25 | 433 |
| Value | Count | Frequency (%) |
| 156296 | 1 | |
| 126743 | 1 | |
| 109177 | 1 | |
| 97635 | 1 | |
| 87806 | 1 | |
| 85822 | 1 | |
| 82148 | 1 | |
| 79930 | 1 | |
| 78464 | 1 | |
| 77374 | 1 |
ae_impressions
Real number (ℝ)
HIGH CORRELATION  SKEWED 
| Distinct | 2448 |
|---|---|
| Distinct (%) | 5.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 257.05514 |
| Minimum | 16 |
|---|---|
| Maximum | 69448 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 374.6 KiB |
Quantile statistics
| Minimum | 16 |
|---|---|
| 5-th percentile | 17 |
| Q1 | 27 |
| median | 52 |
| Q3 | 140 |
| 95-th percentile | 839 |
| Maximum | 69448 |
| Range | 69432 |
| Interquartile range (IQR) | 113 |
Descriptive statistics
| Standard deviation | 1294.3136 |
|---|---|
| Coefficient of variation (CV) | 5.0351593 |
| Kurtosis | 637.41982 |
| Mean | 257.05514 |
| Median Absolute Deviation (MAD) | 31 |
| Skewness | 21.146849 |
| Sum | 12321938 |
| Variance | 1675247.6 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 16 | 1396 | 2.9% |
| 17 | 1363 | 2.8% |
| 18 | 1227 | 2.6% |
| 19 | 1206 | 2.5% |
| 20 | 1079 | 2.3% |
| 21 | 1013 | 2.1% |
| 22 | 932 | 1.9% |
| 23 | 928 | 1.9% |
| 24 | 867 | 1.8% |
| 25 | 803 | 1.7% |
| Other values (2438) | 37121 |
| Value | Count | Frequency (%) |
| 16 | 1396 | |
| 17 | 1363 | |
| 18 | 1227 | |
| 19 | 1206 | |
| 20 | 1079 | |
| 21 | 1013 | |
| 22 | 932 | |
| 23 | 928 | |
| 24 | 867 | |
| 25 | 803 |
| Value | Count | Frequency (%) |
| 69448 | 1 | |
| 57126 | 1 | |
| 48011 | 1 | |
| 44503 | 1 | |
| 41852 | 1 | |
| 41785 | 1 | |
| 39941 | 1 | |
| 38639 | 1 | |
| 38097 | 1 | |
| 37877 | 1 |
ae_clicks
Real number (ℝ)
HIGH CORRELATION  SKEWED  ZEROS 
| Distinct | 481 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.502514 |
| Minimum | 0 |
|---|---|
| Maximum | 6853 |
| Zeros | 14839 |
| Zeros (%) | 31.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 374.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 2 |
| Q3 | 7 |
| 95-th percentile | 54 |
| Maximum | 6853 |
| Range | 6853 |
| Interquartile range (IQR) | 7 |
Descriptive statistics
| Standard deviation | 73.922916 |
|---|---|
| Coefficient of variation (CV) | 5.4747521 |
| Kurtosis | 2442.3768 |
| Mean | 13.502514 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 38.077571 |
| Sum | 647243 |
| Variance | 5464.5975 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 14839 | |
| 1 | 6651 | |
| 2 | 4371 | 9.1% |
| 3 | 3168 | 6.6% |
| 4 | 2428 | 5.1% |
| 5 | 1832 | 3.8% |
| 6 | 1540 | 3.2% |
| 7 | 1292 | 2.7% |
| 8 | 1043 | 2.2% |
| 9 | 853 | 1.8% |
| Other values (471) | 9918 |
| Value | Count | Frequency (%) |
| 0 | 14839 | |
| 1 | 6651 | |
| 2 | 4371 | 9.1% |
| 3 | 3168 | 6.6% |
| 4 | 2428 | 5.1% |
| 5 | 1832 | 3.8% |
| 6 | 1540 | 3.2% |
| 7 | 1292 | 2.7% |
| 8 | 1043 | 2.2% |
| 9 | 853 | 1.8% |
| Value | Count | Frequency (%) |
| 6853 | 1 | |
| 4415 | 1 | |
| 4227 | 1 | |
| 3537 | 1 | |
| 3310 | 1 | |
| 2872 | 1 | |
| 2851 | 1 | |
| 2748 | 1 | |
| 2291 | 1 | |
| 2247 | 1 |
ae_revenue
Real number (ℝ)
HIGH CORRELATION  SKEWED 
| Distinct | 43914 |
|---|---|
| Distinct (%) | 91.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.0983199 |
| Minimum | 0.000111 |
|---|---|
| Maximum | 2137.1819 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 374.6 KiB |
Quantile statistics
| Minimum | 0.000111 |
|---|---|
| 5-th percentile | 0.0036861 |
| Q1 | 0.0260465 |
| median | 0.112968 |
| Q3 | 0.537878 |
| 95-th percentile | 4.7054774 |
| Maximum | 2137.1819 |
| Range | 2137.1818 |
| Interquartile range (IQR) | 0.5118315 |
Descriptive statistics
| Standard deviation | 27.784254 |
|---|---|
| Coefficient of variation (CV) | 13.24119 |
| Kurtosis | 2246.4576 |
| Mean | 2.0983199 |
| Median Absolute Deviation (MAD) | 0.104059 |
| Skewness | 42.191015 |
| Sum | 100582.97 |
| Variance | 771.96476 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.006658 | 6 | < 0.1% |
| 0.002566 | 6 | < 0.1% |
| 0.002842 | 6 | < 0.1% |
| 0.00445 | 5 | < 0.1% |
| 0.002506 | 5 | < 0.1% |
| 0.006756 | 5 | < 0.1% |
| 0.005598 | 5 | < 0.1% |
| 0.003386 | 5 | < 0.1% |
| 0.003614 | 5 | < 0.1% |
| 0.002626 | 5 | < 0.1% |
| Other values (43904) | 47882 |
| Value | Count | Frequency (%) |
| 0.000111 | 1 | |
| 0.000122 | 1 | |
| 0.000134 | 1 | |
| 0.000143 | 1 | |
| 0.000154 | 1 | |
| 0.000159 | 1 | |
| 0.000162 | 1 | |
| 0.000167 | 1 | |
| 0.000169 | 1 | |
| 0.000177 | 1 |
| Value | Count | Frequency (%) |
| 2137.181915 | 1 | |
| 1860.866497 | 1 | |
| 1641.986936 | 1 | |
| 1457.692016 | 1 | |
| 1358.036254 | 1 | |
| 1327.266005 | 1 | |
| 1296.540283 | 1 | |
| 1241.249077 | 1 | |
| 954.945284 | 1 | |
| 925.251211 | 1 |
Unnamed: 10
Categorical
CONSTANT  MISSING 
| Distinct | 1 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 47934 |
| Missing (%) | > 99.9% |
| Memory size | 374.6 KiB |
| #NAME? |
|---|
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 6 |
| Min length | 6 |
Characters and Unicode
| Total characters | 6 |
|---|---|
| Distinct characters | 6 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | #NAME? |
|---|
Common Values
| Value | Count | Frequency (%) |
| #NAME? | 1 | < 0.1% |
| (Missing) | 47934 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| name | 1 |
Most occurring characters
| Value | Count | Frequency (%) |
| # | 1 | |
| N | 1 | |
| A | 1 | |
| M | 1 | |
| E | 1 | |
| ? | 1 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 4 | |
| Other Punctuation | 2 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 1 | |
| A | 1 | |
| M | 1 | |
| E | 1 |
Other Punctuation
| Value | Count | Frequency (%) |
| # | 1 | |
| ? | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 4 | |
| Common | 2 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| N | 1 | |
| A | 1 | |
| M | 1 | |
| E | 1 |
Common
| Value | Count | Frequency (%) |
| # | 1 | |
| ? | 1 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 6 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| # | 1 | |
| N | 1 | |
| A | 1 | |
| M | 1 | |
| E | 1 | |
| ? | 1 |
Unnamed: 11
Categorical
CONSTANT  MISSING 
| Distinct | 1 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 47934 |
| Missing (%) | > 99.9% |
| Memory size | 374.6 KiB |
| #NAME? |
|---|
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 6 |
| Min length | 6 |
Characters and Unicode
| Total characters | 6 |
|---|---|
| Distinct characters | 6 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | #NAME? |
|---|
Common Values
| Value | Count | Frequency (%) |
| #NAME? | 1 | < 0.1% |
| (Missing) | 47934 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| name | 1 |
Most occurring characters
| Value | Count | Frequency (%) |
| # | 1 | |
| N | 1 | |
| A | 1 | |
| M | 1 | |
| E | 1 | |
| ? | 1 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 4 | |
| Other Punctuation | 2 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 1 | |
| A | 1 | |
| M | 1 | |
| E | 1 |
Other Punctuation
| Value | Count | Frequency (%) |
| # | 1 | |
| ? | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 4 | |
| Common | 2 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| N | 1 | |
| A | 1 | |
| M | 1 | |
| E | 1 |
Common
| Value | Count | Frequency (%) |
| # | 1 | |
| ? | 1 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 6 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| # | 1 | |
| N | 1 | |
| A | 1 | |
| M | 1 | |
| E | 1 | |
| ? | 1 |
Unnamed: 12
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 47935 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 374.6 KiB |
Unnamed: 13
Categorical
HIGH CORRELATION  MISSING  UNIFORM 
| Distinct | 6 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 47929 |
| Missing (%) | > 99.9% |
| Memory size | 374.6 KiB |
| b1 | |
|---|---|
| b2 | |
| b3 | |
| b4 | |
| b5 |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 12 |
|---|---|
| Distinct characters | 7 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 6 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | b1 |
|---|---|
| 2nd row | b2 |
| 3rd row | b3 |
| 4th row | b4 |
| 5th row | b5 |
Common Values
| Value | Count | Frequency (%) |
| b1 | 1 | < 0.1% |
| b2 | 1 | < 0.1% |
| b3 | 1 | < 0.1% |
| b4 | 1 | < 0.1% |
| b5 | 1 | < 0.1% |
| b6 | 1 | < 0.1% |
| (Missing) | 47929 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| b1 | 1 | |
| b2 | 1 | |
| b3 | 1 | |
| b4 | 1 | |
| b5 | 1 | |
| b6 | 1 |
Most occurring characters
| Value | Count | Frequency (%) |
| b | 6 | |
| 1 | 1 | 8.3% |
| 2 | 1 | 8.3% |
| 3 | 1 | 8.3% |
| 4 | 1 | 8.3% |
| 5 | 1 | 8.3% |
| 6 | 1 | 8.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 6 | |
| Decimal Number | 6 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 |
Lowercase Letter
| Value | Count | Frequency (%) |
| b | 6 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 6 | |
| Common | 6 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 |
Latin
| Value | Count | Frequency (%) |
| b | 6 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 12 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| b | 6 | |
| 1 | 1 | 8.3% |
| 2 | 1 | 8.3% |
| 3 | 1 | 8.3% |
| 4 | 1 | 8.3% |
| 5 | 1 | 8.3% |
| 6 | 1 | 8.3% |
Unnamed: 14
Categorical
HIGH CORRELATION  MISSING  UNIFORM 
| Distinct | 5 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 47930 |
| Missing (%) | > 99.9% |
| Memory size | 374.6 KiB |
| 1.0 | |
|---|---|
| 100.0 | |
| 300.0 | |
| 600.0 | |
| 1500.0 |
Length
| Max length | 6 |
|---|---|
| Median length | 5 |
| Mean length | 4.8 |
| Min length | 3 |
Characters and Unicode
| Total characters | 24 |
|---|---|
| Distinct characters | 6 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 5 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | 1.0 |
|---|---|
| 2nd row | 100.0 |
| 3rd row | 300.0 |
| 4th row | 600.0 |
| 5th row | 1500.0 |
Common Values
| Value | Count | Frequency (%) |
| 1.0 | 1 | < 0.1% |
| 100.0 | 1 | < 0.1% |
| 300.0 | 1 | < 0.1% |
| 600.0 | 1 | < 0.1% |
| 1500.0 | 1 | < 0.1% |
| (Missing) | 47930 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1.0 | 1 | |
| 100.0 | 1 | |
| 300.0 | 1 | |
| 600.0 | 1 | |
| 1500.0 | 1 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 13 | |
| . | 5 | 20.8% |
| 1 | 3 | 12.5% |
| 3 | 1 | 4.2% |
| 6 | 1 | 4.2% |
| 5 | 1 | 4.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 19 | |
| Other Punctuation | 5 | 20.8% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 13 | |
| 1 | 3 | 15.8% |
| 3 | 1 | 5.3% |
| 6 | 1 | 5.3% |
| 5 | 1 | 5.3% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 5 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 24 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 13 | |
| . | 5 | 20.8% |
| 1 | 3 | 12.5% |
| 3 | 1 | 4.2% |
| 6 | 1 | 4.2% |
| 5 | 1 | 4.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 24 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 13 | |
| . | 5 | 20.8% |
| 1 | 3 | 12.5% |
| 3 | 1 | 4.2% |
| 6 | 1 | 4.2% |
| 5 | 1 | 4.2% |
Unnamed: 15
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 6 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 47929 |
| Missing (%) | > 99.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 773 |
| Minimum | 0 |
|---|---|
| Maximum | 2138 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 374.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 25 |
| Q1 | 150 |
| median | 450 |
| Q3 | 1275 |
| 95-th percentile | 1978.5 |
| Maximum | 2138 |
| Range | 2138 |
| Interquartile range (IQR) | 1125 |
Descriptive statistics
| Standard deviation | 859.75229 |
|---|---|
| Coefficient of variation (CV) | 1.1122281 |
| Kurtosis | -0.6588904 |
| Mean | 773 |
| Median Absolute Deviation (MAD) | 400 |
| Skewness | 0.96765175 |
| Sum | 4638 |
| Variance | 739174 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 100 | 1 | < 0.1% |
| 300 | 1 | < 0.1% |
| 600 | 1 | < 0.1% |
| 1500 | 1 | < 0.1% |
| 2138 | 1 | < 0.1% |
| (Missing) | 47929 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 100 | 1 | |
| 300 | 1 | |
| 600 | 1 | |
| 1500 | 1 | |
| 2138 | 1 |
| Value | Count | Frequency (%) |
| 2138 | 1 | |
| 1500 | 1 | |
| 600 | 1 | |
| 300 | 1 | |
| 100 | 1 | |
| 0 | 1 |
| pub_id | app_id | ad_unit_code | requests | ae_responses | ae_impressions | ae_clicks | ae_revenue | Unnamed: 15 | date | Unnamed: 13 | Unnamed: 14 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| pub_id | 1.000 | 0.072 | -0.389 | -0.167 | -0.157 | -0.196 | -0.308 | -0.205 | NaN | 0.110 | 1.000 | 1.000 |
| app_id | 0.072 | 1.000 | -0.087 | -0.310 | -0.299 | -0.187 | -0.226 | -0.303 | NaN | 0.081 | 1.000 | 1.000 |
| ad_unit_code | -0.389 | -0.087 | 1.000 | 0.097 | 0.124 | 0.083 | 0.025 | 0.104 | -0.717 | 0.087 | 1.000 | 1.000 |
| requests | -0.167 | -0.310 | 0.097 | 1.000 | 0.986 | 0.905 | 0.467 | 0.478 | -0.086 | 0.000 | 1.000 | 1.000 |
| ae_responses | -0.157 | -0.299 | 0.124 | 0.986 | 1.000 | 0.919 | 0.484 | 0.506 | -0.143 | 0.000 | 1.000 | 1.000 |
| ae_impressions | -0.196 | -0.187 | 0.083 | 0.905 | 0.919 | 1.000 | 0.525 | 0.566 | -0.086 | 0.000 | 1.000 | 1.000 |
| ae_clicks | -0.308 | -0.226 | 0.025 | 0.467 | 0.484 | 0.525 | 1.000 | 0.706 | 0.000 | 0.008 | 1.000 | 1.000 |
| ae_revenue | -0.205 | -0.303 | 0.104 | 0.478 | 0.506 | 0.566 | 0.706 | 1.000 | -0.029 | 0.000 | 1.000 | 1.000 |
| Unnamed: 15 | NaN | NaN | -0.717 | -0.086 | -0.143 | -0.086 | 0.000 | -0.029 | 1.000 | 1.000 | 1.000 | 1.000 |
| date | 0.110 | 0.081 | 0.087 | 0.000 | 0.000 | 0.000 | 0.008 | 0.000 | 1.000 | 1.000 | 1.000 | 1.000 |
| Unnamed: 13 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 |
| Unnamed: 14 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 |
| date | pub_id | app_id | ad_unit_code | country | requests | ae_responses | ae_impressions | ae_clicks | ae_revenue | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 20-10-2022 | 1987 | 16243270 | 22832846443 | Tanzania | 36 | 36 | 34 | 0 | 0.035738 | #NAME? | NaN | NaN | NaN | NaN | NaN |
| 1 | 20-10-2022 | 1987 | 16243270 | 22832846593 | Tanzania | 24 | 24 | 23 | 0 | 0.064384 | NaN | #NAME? | NaN | b1 | NaN | 0.0 |
| 2 | 20-10-2022 | 1987 | 16243270 | 22832846443 | Thailand | 949 | 949 | 876 | 20 | 4.943878 | NaN | NaN | NaN | b2 | 1.0 | 100.0 |
| 3 | 20-10-2022 | 1987 | 16243270 | 22832846593 | Thailand | 1006 | 907 | 688 | 134 | 24.226836 | NaN | NaN | NaN | b3 | 100.0 | 300.0 |
| 4 | 20-10-2022 | 1987 | 16243270 | 22832827729 | Thailand | 373 | 287 | 156 | 20 | 2.759392 | NaN | NaN | NaN | b4 | 300.0 | 600.0 |
| 5 | 20-10-2022 | 1987 | 16243270 | 22832846443 | United States | 225 | 225 | 212 | 2 | 4.316628 | NaN | NaN | NaN | b5 | 600.0 | 1500.0 |
| 6 | 20-10-2022 | 1987 | 16243270 | 22832827729 | United States | 39 | 39 | 30 | 2 | 1.450446 | NaN | NaN | NaN | b6 | 1500.0 | 2138.0 |
| 7 | 20-10-2022 | 1987 | 16243270 | 22832846593 | United States | 189 | 189 | 165 | 4 | 20.327859 | NaN | NaN | NaN | NaN | NaN | NaN |
| 8 | 20-10-2022 | 1987 | 16243270 | 22832846593 | United Kingdom | 33 | 33 | 25 | 1 | 1.874777 | NaN | NaN | NaN | NaN | NaN | NaN |
| 9 | 20-10-2022 | 1987 | 16243270 | 22832846443 | United Kingdom | 37 | 37 | 36 | 1 | 0.269845 | NaN | NaN | NaN | NaN | NaN | NaN |
| date | pub_id | app_id | ad_unit_code | country | requests | ae_responses | ae_impressions | ae_clicks | ae_revenue | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 47925 | 22-10-2022 | 14 | 95674771 | 22770341598 | Venezuela | 20 | 20 | 19 | 3 | 0.035682 | NaN | NaN | NaN | NaN | NaN | NaN |
| 47926 | 22-10-2022 | 14 | 95674771 | 22770341049 | Albania | 29 | 29 | 20 | 5 | 0.082596 | NaN | NaN | NaN | NaN | NaN | NaN |
| 47927 | 22-10-2022 | 14 | 95674771 | 22770341049 | Peru | 40 | 40 | 20 | 2 | 0.076515 | NaN | NaN | NaN | NaN | NaN | NaN |
| 47928 | 22-10-2022 | 14 | 95674771 | 22770341049 | Philippines | 40 | 36 | 20 | 4 | 0.112624 | NaN | NaN | NaN | NaN | NaN | NaN |
| 47929 | 22-10-2022 | 14 | 95674771 | 22770341049 | Switzerland | 37 | 37 | 20 | 3 | 1.466152 | NaN | NaN | NaN | NaN | NaN | NaN |
| 47930 | 22-10-2022 | 14 | 95674771 | 22770341049 | El Salvador | 34 | 34 | 21 | 4 | 0.022347 | NaN | NaN | NaN | NaN | NaN | NaN |
| 47931 | 22-10-2022 | 14 | 95674771 | 22770341430 | Jordan | 34 | 34 | 21 | 0 | 0.011894 | NaN | NaN | NaN | NaN | NaN | NaN |
| 47932 | 22-10-2022 | 14 | 95674771 | 22770341430 | Somalia | 46 | 46 | 21 | 2 | 0.003189 | NaN | NaN | NaN | NaN | NaN | NaN |
| 47933 | 22-10-2022 | 14 | 95674771 | 22770341598 | Portugal | 21 | 21 | 21 | 5 | 0.159408 | NaN | NaN | NaN | NaN | NaN | NaN |
| 47934 | 22-10-2022 | 14 | 95674771 | 22770341049 | Thailand | 40 | 40 | 21 | 1 | 0.140938 | NaN | NaN | NaN | NaN | NaN | NaN |